Comparing Dates to Current Time

Поиск
Список
Период
Сортировка
От Jenny DiBartolomeo
Тема Comparing Dates to Current Time
Дата
Msg-id v04011712b31ee8bd44b3@[206.100.119.176]
обсуждение исходный текст
Список pgsql-sql
OK... this is probably a trivial one.  In an Oracle query, I might do the
following select statement:

   SELECT title

     FROM articles

    WHERE expires > SYSDATE

How would I do the same thing in Postgres if the column "expires" is of the
data type "DATE"?  I've tried everything and read the man pages and can't
seem to get it working!  Any help would be VERY APPRECIATED!!!

Thanks sooooo much for any help you can give me!!!!  Please respond via
email to jdibartolomeo@agency.com.

-Jenny

------------------------------
Jennifer DiBartolomeo
jdibartolomeo@agency.com
------------------------------

В списке pgsql-sql по дате отправления:

Предыдущее
От: Jenny DiBartolomeo
Дата:
Сообщение: Comparing Dates to Current Time
Следующее
От: "Ing. Roberto Andrade"
Дата:
Сообщение: Use of 'default TEXT now()'